USE [PatientRecord]
GO

/****** Object:  StoredProcedure [dbo].[logincheck]    Script Date: 04/22/2010 02:27:59 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE PROCEDURE [dbo].[logincheck] 

@PName nvarchar(50),
@Pwd nvarchar(100)

AS
BEGIN

Select Pid from Patient where PName=@PName and Pwd = @Pwd
    
END


GO


